SELECT c.FirstName & " " & c.LastName AS FullName, SUM(st.TotalAmount) AS TotalSpent
FROM Customer c INNER JOIN Sale_Transaction st ON c.CustomerID = st.CustomerID
GROUP BY c.FirstName & " " & c.LastName;